Skip to main content

Material Table

This table, named SF_Material Table, contains the material names and information associated with the material. SF_Material Table has the column format shown in the following table.

SF_Material Table Format

ColumnDescriptionUsed By
MaterialMaterial NameUsed in the Sigmafine Data Reference and the Gross Error Detection Analysis Rule.
Material DescriptionDescription of the materialFor Reporting
Material GroupGroup ClassificationFor Reporting
Group DescriptionMaterial Group descriptionFor Reporting
Material CostCosting informationFor Reporting
Material DensityAverage density of the materialUsed in the Sigmafine Data Reference and the Gross Error Detection Analysis Rule.
VCF TypeVCF calculation type.Used in the Sigmafine Data Reference VCF Calculation.
Special Material Group 1An integer value that indicates special processing by the Composition Tracking Rule.Composition Tracking Analysis Rule
Material FamilyThe family classification of the materialFor Reporting
From PlantIdentifies a facility in which a material is made, from where it is purchased, etc.For Reporting
Material CategoryThe category classification of the materialFor Reporting
Material OrderAn index number to aid in organizationFor Reporting
Physical StateThe physical state of the materialFor Reporting
IS ChargeIf the material is a charge material, then a Y is placed in this field.For Reporting
Sorting IndexAn index number to aid in organizationFor Reporting
Tracking GroupA sub-grouping for composition trackingFor Reporting
1 \For more information, see the topic under Analysis Rules > Inventory Calculation Methods.

The SF_Material table is shown in the following example image.

ClosedEXAMPLE: SF_Material TableFigure 205: SF_Material Table